[dbo].[asi_GroupMembershipByType]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_GroupMembershipByType

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@contactKey	uniqueidentifier	16
@groupTypeKey	uniqueidentifier	16

SQL Script

CREATE PROCEDURE [dbo].[asi_GroupMembershipByType] (@contactKey uniqueidentifier, @groupTypeKey uniqueidentifier)
AS
BEGIN

SELECT DISTINCT GroupMain.GroupKey, GroupMain.Name
FROM    GroupMember INNER JOIN
    GroupMain ON GroupMember.GroupKey = GroupMain.GroupKey
WHERE     (GroupMember.MemberContactKey = @contactKey) AND
         (GroupMain.GroupTypeKey = @groupTypeKey)
ORDER BY GroupMain.Name
END

GO

Uses

[dbo].[GroupMain]
[dbo].[GroupMember]
dbo